Telegram Group & Telegram Channel
Forwarded from Excel Hacks
Туғилган кунлар кетма-кетлиги.

Туғилган кунларни саралашда муаммолар юзага келиши мумкин, чунки Excel саналарни йил бўйича саралайди.

1️⃣ Бу масалани ечиш учун, биз сананинг бироз ностандарт кўринишидан фойдаланамиз. Яъни аввал ой, кейин кунни битта ячейкага қуйидаги формула ёрдамида матн сифатида бирлаштирамиз.

=ТЕКСТ(B3;"ММДД")

2️⃣ Шакллантирилган матнлларни кўпайиб бориш бўйича саралаб олинг.


Шунда туғилган кунлар кетма-кет жойлашади.


Каналга уланинг
👉 Excel Hacks | 🚀 Excel Hacks Videokursi



tg-me.com/excel_hacks/753
Create:
Last Update:

Туғилган кунлар кетма-кетлиги.

Туғилган кунларни саралашда муаммолар юзага келиши мумкин, чунки Excel саналарни йил бўйича саралайди.

1️⃣ Бу масалани ечиш учун, биз сананинг бироз ностандарт кўринишидан фойдаланамиз. Яъни аввал ой, кейин кунни битта ячейкага қуйидаги формула ёрдамида матн сифатида бирлаштирамиз.

=ТЕКСТ(B3;"ММДД")

2️⃣ Шакллантирилган матнлларни кўпайиб бориш бўйича саралаб олинг.


Шунда туғилган кунлар кетма-кет жойлашади.


Каналга уланинг
👉 Excel Hacks | 🚀 Excel Hacks Videokursi

BY Excel Hacks




Share with your friend now:
tg-me.com/excel_hacks/753

View MORE
Open in Telegram


Excel Hacks Telegram | DID YOU KNOW?

Date: |

Tata Power whose core business is to generate, transmit and distribute electricity has made no money to investors in the last one decade. That is a big blunder considering it is one of the largest power generation companies in the country. One of the reasons is the company's huge debt levels which stood at ₹43,559 crore at the end of March 2021 compared to the company’s market capitalisation of ₹44,447 crore.

What Is Bitcoin?

Bitcoin is a decentralized digital currency that you can buy, sell and exchange directly, without an intermediary like a bank. Bitcoin’s creator, Satoshi Nakamoto, originally described the need for “an electronic payment system based on cryptographic proof instead of trust.” Each and every Bitcoin transaction that’s ever been made exists on a public ledger accessible to everyone, making transactions hard to reverse and difficult to fake. That’s by design: Core to their decentralized nature, Bitcoins aren’t backed by the government or any issuing institution, and there’s nothing to guarantee their value besides the proof baked in the heart of the system. “The reason why it’s worth money is simply because we, as people, decided it has value—same as gold,” says Anton Mozgovoy, co-founder & CEO of digital financial service company Holyheld.

Excel Hacks from tw


Telegram Excel Hacks
FROM USA